USE [CTEM-DB-v1]
GO

/****** Object:  StoredProcedure [dbo].[WorkerSalary_GetConID]    Script Date: 02/10/2012 11:15:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



-- =============================================
-- Author:		TienDH
-- Create date: 12/05/2011
-- Description:	Get full employee's information
-- =============================================
CREATE PROCEDURE [dbo].[WorkerSalary_GetConID]
		@WorkersSalaryID   bigint
AS
BEGIN
	SELECT	ConstructionID
	FROM	WorkersSalary 	
	WHERE   WorkersSalaryID = @WorkersSalaryID
END
GO

